#!/usr/bin/python
# -*- coding: UTF-8 -*-
# author : bird.zhang@ximalaya.com

import pytz

import pandas as pd

# pytz.country_timezones('cn')
# tz = pytz.timezone('Asia/Shanghai')

df = pd.read_csv('zhoubao-record-20180403.csv', index_col='id')

# 查出20180409这一周的
# df_record = df_record[df_record[date] == ]

# df.info()

# print(df.dtypes)

# 将str转化成pandas.Timestamp
df['date'] = df['date'].map(lambda x: pd.Timestamp(x).astimezone("Asia/Shanghai"))

print(df[0:1]['date'])

# print(df.loc[0, ['date']])

# date_list = df.date.tolist()

# df_record['date'] = pd.to_datetime(df_record['date'], tzinfo=tz)

# df_record = df_record[df_record['date'] == '2018-04-09T00:00:00.000+08:00']
# print(len(df_record))
